USE [xuanfu_chanel]
GO

/******1  ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RT_ACCELRATION_TRANSDUCER](
	[TRANSDUCER_ID] [varchar](36) NOT NULL,
	[TRANSDUCER_NUMBER] [varchar](50) NULL,
	[TRANSDUCER_NAME] [varchar](50) NULL,
	[TRANSDUCER_LOCATION] [varchar](200) NULL,
	[TRANSDUCER_ SERIALPORT] [varchar](200) NULL,
	[TRANSDUCER_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_ACCELRATION_CONTROL](
	[ACCELRATION_CONTROL_ID] [varchar](36) NOT NULL,
	[ACCELRATION_CONTROL_STIME] [datetime] NULL,
	[ACCELRATION_CONTROL_ETIME] [datetime] NULL,
	[ACCELRATION_CONTROL_INTERVAL] int NULL,
	[ACCELRATION_CONTROL_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_ACCELRATION_DATA](
	[ACCELRATION_DATA_ID] [varchar](36) NOT NULL,
	[ACCELRATION_CONTROL_ID] [varchar](36) NULL,
	[ACCELRATION_DATA_TIME] [datetime] NULL,
	[TRANSDUCER_NUMBER] [varchar](36) NULL,
	[ACCELRATION_DATA_XVALUE] [decimal](9, 6) NULL,
	[ACCELRATION_DATA_YVALUE] [decimal](9, 6) NULL,
	[ACCELRATION_DATA_ZVALUE] [decimal](9, 6) NULL,
	[ANGULARVELOCITY_XVALUE] [decimal](9, 6) NULL,
	[ANGULARVELOCITY_YVALUE] [decimal](9, 6) NULL,
	[ANGULARVELOCITY_ZVALUE] [decimal](9, 6) NULL,
	[ANGLE_XVALUE] [decimal](9, 6) NULL,
	[ANGLE_YVALUE] [decimal](9, 6) NULL,
	[ANGLE_ZVALUE] [decimal](9, 6) NULL,
	[MAGNETICFIELD_XVALUE] [decimal](9, 6) NULL,
	[MAGNETICFIELD_YVALUE] [decimal](9, 6) NULL,
	[MAGNETICFIELD_ZVALUE] [decimal](9, 6) NULL,
	[TEMPERATURE_VALUE] [decimal](9, 6) NULL,
	[PRESSURE_VALUE] [decimal](9, 6) NULL,
	[HEIGHT_VALUE] [decimal](9, 6) NULL,
	[QUATERNION0_VALUE] [decimal](9, 6) NULL,
	[QUATERNION1_VALUE] [decimal](9, 6) NULL,
	[QUATERNION2_VALUE] [decimal](9, 6) NULL,
	[QUATERNION3_VALUE] [decimal](9, 6) NULL,
	[PORT0_VALUE] [decimal](9, 6) NULL,
	[PORT1_VALUE] [decimal](9, 6) NULL,
	[PORT2_VALUE] [decimal](9, 6) NULL,
	[PORT3_VALUE] [decimal](9, 6) NULL,
	[STRAIN_DATA_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]



CREATE TABLE [dbo].[RT_CURRENTSPEED_TRANSDUCER](
	[TRANSDUCER_ID] [varchar](36) NOT NULL,
	[TRANSDUCER_NUMBER] [varchar](50) NULL,
	[TRANSDUCER_NAME] [varchar](50) NULL,
	[TRANSDUCER_LOCATION] [varchar](200) NULL,
	[TRANSDUCER_ SERIALPORT] [varchar](200) NULL,
	[TRANSDUCER_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_CURRENTSPEED_CONTROL](
	[CURRENTSPEED_CONTROL_ID] [varchar](36) NOT NULL,
	[CURRENTSPEED_CONTROL_STIME] [datetime] NULL,
	[CURRENTSPEED_CONTROL_ETIME] [datetime] NULL,
	[CURRENTSPEED_CONTROL_INTERVAL] int NULL,
	[CURRENTSPEED_CONTROL_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_CURRENTSPEED_DATA](
	[CURRENTSPEED_DATA_ID] [varchar](36) NOT NULL,
	[CURRENTSPEED_CONTROL_ID] [varchar](36) NULL,
	[TRANSDUCER_NUMBER] [varchar](36) NULL,
	[CURRENTSPEED_DATA_TIME] [datetime] NULL,
	[CURRENTSPEED_VEL1B1X] [decimal](9, 6) NULL,
	[CURRENTSPEED_VEL1B1Y] [decimal](9, 6) NULL,
	[CURRENTSPEED_VEL1B1Z] [decimal](9, 6) NULL,
	[CURRENTSPEED_VEL1B1Z2] [decimal](9, 6) NULL,
	[CURRENTSPEED_CORR1B1] [decimal](9, 6) NULL,
	[CURRENTSPEED_CORR1B2] [decimal](9, 6) NULL,
	[CURRENTSPEED_CORR1B3] [decimal](9, 6) NULL,
	[CURRENTSPEED_CORR1B4] [decimal](9, 6) NULL,
	[CURRENTSPEED_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]



CREATE TABLE [dbo].[RT_FLOW_TRANSDUCER](
	[TRANSDUCER_ID] [varchar](36) NOT NULL,
	[TRANSDUCER_NUMBER] [varchar](50) NULL,
	[TRANSDUCER_NAME] [varchar](50) NULL,
	[TRANSDUCER_LOCATION] [varchar](200) NULL,
	[TRANSDUCER_ SERIALPORT] [varchar](200) NULL,
	[TRANSDUCER_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_FLOW_CONTROL](
	[FLOW_CONTROL_ID] [varchar](36) NOT NULL,
	[FLOW_CONTROL_STIME] [datetime] NULL,
	[FLOW_CONTROL_ETIME] [datetime] NULL,
	[FLOW_CONTROL_INTERVAL] int NULL,
	[FLOW_CONTROL_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_FLOW_DATA](
	[FLOW_DATA_ID] [varchar](36) NOT NULL,
	[FLOW_CONTROL_ID] [varchar](36) NULL,
	[TRANSDUCER_NUMBER] [varchar](36) NULL,
	[FLOW_DATA_TIME] [datetime] NULL,
	[FLOW_DATA_VALUE] [decimal](9, 6) NULL,
	[FLOW_DATA_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]



CREATE TABLE [dbo].[RT_PULL_TRANSDUCER](
	[TRANSDUCER_ID] [varchar](36) NOT NULL,
	[TRANSDUCER_NUMBER] [varchar](50) NULL,
	[TRANSDUCER_NAME] [varchar](50) NULL,
	[TRANSDUCER_LOCATION] [varchar](200) NULL,
	[TRANSDUCER_ SERIALPORT] [varchar](200) NULL,
	[TRANSDUCER_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_PULL_CONTROL](
	[PULL_CONTROL_ID] [varchar](36) NOT NULL,
	[PULL_CONTROL_STIME] [datetime] NULL,
	[PULL_CONTROL_ETIME] [datetime] NULL,
	[PULL_CONTROL_INTERVAL] int NULL,
	[PULL_CONTROL_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_PULL_DATA](
	[PULL_DATA_ID] [varchar](36) NOT NULL,
	[PULL_CONTROL_ID] [varchar](36) NULL,
	[TRANSDUCER_NUMBER] [varchar](36) NULL,
	[PULL_DATA_TIME] [datetime] NULL,
	[PULL_DATA_VALUE] [decimal](9, 6) NULL,
	[PULL_DATA_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]



CREATE TABLE [dbo].[RT_STRAIN_TRANSDUCER](
	[TRANSDUCER_ID] [varchar](36) NOT NULL,
	[TRANSDUCER_NUMBER] [varchar](50) NULL,
	[TRANSDUCER_NAME] [varchar](50) NULL,
	[TRANSDUCER_LOCATION] [varchar](200) NULL,
	[TRANSDUCER_ SERIALPORT] [varchar](200) NULL,
	[TRANSDUCER_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_STRAIN_CONTROL](
	[STRAIN_CONTROL_ID] [varchar](36) NOT NULL,
	[STRAIN_CONTROL_STIME] [datetime] NULL,
	[STRAIN_CONTROL_ETIME] [datetime] NULL,
	[STRAIN_CONTROL_INTERVAL] int NULL,
	[STRAIN_CONTROL_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_STRAIN_DATA](
	[STRAIN_DATA_ID] [varchar](36) NOT NULL,
	[STRAIN_CONTROL_ID] [varchar](36) NULL,
	[TRANSDUCER_NUMBER] [varchar](36) NULL,
	[STRAIN_DATA_TIME] [datetime] NULL,
	[STRAIN_DATA_VALUE] [decimal](9, 6) NULL,
	[STRAIN_DATA_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]



CREATE TABLE [dbo].[RT_WAVEHEIGHT_TRANSDUCER](
	[TRANSDUCER_ID] [varchar](36) NOT NULL,
	[TRANSDUCER_NUMBER] [varchar](50) NULL,
	[TRANSDUCER_NAME] [varchar](50) NULL,
	[TRANSDUCER_LOCATION] [varchar](200) NULL,
	[TRANSDUCER_ SERIALPORT] [varchar](200) NULL,
	[TRANSDUCER_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_WAVEHEIGHT_CONTROL](
	[WAVEHEIGHT_CONTROL_ID] [varchar](36) NOT NULL,
	[WAVEHEIGHT_CONTROL_STIME] [datetime] NULL,
	[WAVEHEIGHT_CONTROL_ETIME] [datetime] NULL,
	[WAVEHEIGHT_CONTROL_INTERVAL] int NULL,
	[WAVEHEIGHT_CONTROL_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[RT_WAVEHEIGHT_DATA](
	[WAVEHEIGHT_DATA_ID] [varchar](36) NOT NULL,
	[WAVEHEIGHT_CONTROL_ID] [varchar](36) NULL,
	[TRANSDUCER_NUMBER] [varchar](36) NULL,
	[WAVEHEIGHT_DATA_TIME] [datetime] NULL,
	[WAVEHEIGHT_DATA_VALUE] [decimal](9, 6) NULL,
	[WAVEHEIGHT_DATA_REMARKS] [nvarchar](500) NULL,
	[CREATE_DATE] [datetime] NULL,
	[UPDATE_DATE] [datetime] NULL
) ON [PRIMARY]


GO































